{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Data","Computation","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Data","index":0,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,0,15,2],[10,0,10,2],[14,0,14,2],[0,0,0,2],[1,0,1,2],[12,0,12,2],[13,0,13,2],[11,0,11,2]]}
["National Housing Bank"]
["Subsidy Calculator for Pradhan Mantri Awas Yojana – Credit Linked Subsidy Scheme (EWS/LIG)"]
["First Disbursement Date","2017-01-01","Date should be on or after 01-jan-2017"]
["Current Disbursement Date (for which subsidy claimed)","2017-01-10","Date should  be on or after first disbursement date"]
["Loan Tenure (in months)",240,"Numeric Integer only"]
["Current Disbursement Installment (in Rs.)",600000,"Numeric Integer only"]
["Amount Disbursed before this installment (in Rs.)",0,"Numeric Integer only"]
["Applied Interest Rate for subsidy calculation (in % p.a)",6.5,"NO input data"]
["Subsidy Amount",267279.60681703506]
[]
["Assumptions:"]
["a. Interest for calculation of subsidy is arrived at by applying interest @ 6.5% p.a. on the disbursed amount and on monthly rest basis"]
["b. Subsidy is calculated for a maximum tenure of 240 months (20 years) from first disbursement."]
["c. NPV is calculated at the discount rate of 9% and on monthly rest basis."]
["d. Interest Subsidy is calculated for eligible disbursement amount  upto first Rs 6 lakh of loan amount."]
["e. Paisa is rounded off to the nearest rupee in the total"]

{"sheet":"Computation","index":1,"n_rows":243,"n_cols":14,"rows_kept":243,"cut":false,"hidden":false,"merged":[]}
["Parameters",null,"Loan Amount",{"$f":"IF((Data!B7+Data!B6)>600000,600000-Data!B7,Data!B6)","v":600000},"Loan Tenure",{"$f":"IF(Data!B5>240,240,Data!B5)","v":240},"Cur Inst Tenure",{"$f":"IF(Data!B4=\"\",0, F1-((YEAR(Data!B4)-YEAR(Data!B3))*12+MONTH(Data!B4)-MONTH(Data!B3)))","v":240},"Int Rate",{"$f":"IF(Data!B8>6.5,6.5,Data!B8)","v":6.5},"r ",{"$f":"J1/1200","v":5.4166666666666669E-3},"(1+r)^n-1",{"$f":"((1+L1)^H1)-1","v":2.6564467018910145}]
[null,"BALANCE","EMI","INTEREST","principal repayment","CL BALANCE","NPV(By Formula)",null,null,"EMI",{"$f":"IF($N$1=0,0,($D$1*$L$1)*((1+$L$1)^$H$1)/$N$1)","v":4473.4388130906073}]
[1,{"$f":"D1","v":600000},{"$f":"K2","v":4473.4388130906073},{"$f":"B3*$J$1/(1200)","v":3250},{"$f":"C3-D3","v":1223.4388130906073},{"$f":"B3-E3","v":598776.56118690944},{"$f":"D3/POWER(1+9/1200,A3)","v":3225.8064516129029}]
[{"$f":"A3+1","v":2},{"$f":"IF(F3>0,F3,0)","v":598776.56118690944},{"$f":"IF(B4>0,C3,0)","v":4473.4388130906073},{"$f":"B4*$J$1/1200","v":3243.3730397624263},{"$f":"C4-D4","v":1230.065773328181},{"$f":"B4-E4","v":597546.49541358126},{"$f":"D4/POWER(1+9/1200,A4)","v":3195.2643410278256}]
[{"$f":"A4+1","v":3},{"$f":"IF(F4>0,F4,0)","v":597546.49541358126},{"$f":"IF(B5>0,C4,0)","v":4473.4388130906073},{"$f":"B5*$J$1/1200","v":3236.7101834902319},1236.7286296003754,596309.76678398089,3164.9630911978361]
[4,596309.76678398089,4473.4388130906073,3230.0112367465631,1243.4275763440442,595066.33920763689,3134.9008811989302]
[5,595066.33920763689,4473.4388130906073,3223.2760040413664,1250.1628090492409,593816.17639858765,3105.0759037200942]
[6,593816.17639858765,4473.4388130906073,3216.504288825683,1256.9345242649242,592559.24187432276,3075.4863649618474]
[7,592559.24187432276,4473.4388130906073,3209.6958934859149,1263.7429196046924,591295.49895471812,3046.1304845355426]
[8,591295.49895471812,4473.4388130906073,3202.8506193380567,1270.5881937525505,590024.91076096555,3017.0064953634151]
[9,590024.91076096555,4473.4388130906073,3195.9682666218969,1277.4705464687104,588747.4402144968,2988.1126435793713]
[10,588747.4402144968,4473.4388130906073,3189.048634495191,1284.3901785954163,587463.05003590137,2959.4471884305258,"Total NPV as per Manual Formula",{"$f":"SUM(G3:G242)","v":267279.60681703506}]
[11,587463.05003590137,4473.4388130906073,3182.091521027799,1291.3472920628083,586171.70274383854,2931.0084021794637,"NPV by Excel Formula",{"$f":"NPV(9/1200,D3:D242)","v":267279.60681703564}]
[12,586171.70274383854,4473.4388130906073,3175.096723195792,1298.3420898948152,584873.36065394373,2902.7945700072346]
[13,584873.36065394373,4473.4388130906073,3168.0640368755285,1305.3747762150788,583567.98587772867,2874.8039899170662]
[14,583567.98587772867,4473.4388130906073,3160.9932568376971,1312.4455562529101,582255.54032147571,2847.0349726387954]
[15,582255.54032147571,4473.4388130906073,3153.8841767413264,1319.5546363492808,580935.98568512639,2819.4858415340154]
[16,580935.98568512639,4473.4388130906073,3146.7365891277682,1326.7022239628391,579609.28346116352,2792.1549325019269]
[17,579609.28346116352,4473.4388130906073,3139.5502854146357,1333.8885276759715,578275.39493348752,2765.0405938858803]
[18,578275.39493348752,4473.4388130906073,3132.3250558897239,1341.1137572008834,576934.28117628663,2738.1411863806352]
[19,576934.28117628663,4473.4388130906073,3125.0606897048856,1348.3781233857217,575585.90305290092,2711.4550829402906]
[20,575585.90305290092,4473.4388130906073,3117.7569748698802,1355.6818382207271,574230.22121468023,2684.9806686869088]
[21,574230.22121468023,4473.4388130906073,3110.4136982461846,1363.0251148444227,572867.1960998358,2658.7163408198217]
[22,572867.1960998358,4473.4388130906073,3103.0306455407772,1370.4081675498301,571496.78793228592,2632.6605085256083]
[23,571496.78793228592,4473.4388130906073,3095.6076012998819,1377.8312117907253,570118.95672049525,2606.8115928887473]
[24,570118.95672049525,4473.4388130906073,3088.1443489026824,1385.2944641879249,568733.66225630732,2581.1680268029272]
[25,568733.66225630732,4473.4388130906073,3080.640670554998,1392.7981425356093,567340.86411377171,2555.7282548830258]
[26,567340.86411377171,4473.4388130906073,3073.0963472829303,1400.3424658076769,565940.52164796402,2530.4907333777396]
[27,565940.52164796402,4473.4388130906073,3065.511158926472,1407.9276541641352,564532.59399379988,2505.453930082866]
[28,564532.59399379988,4473.4388130906073,3057.8848841330828,1415.5539289575245,563117.04006484232,2480.6163242552293]
[29,563117.04006484232,4473.4388130906073,3050.2173003512289,1423.2215127393783,561693.81855210289,2455.976406527252]
[30,561693.81855210289,4473.4388130906073,3042.5081838238907,1430.9306292667166,560262.88792283623,2431.532678822156]
[31,560262.88792283623,4473.4388130906073,3034.7573095820298,1438.6815035085774,558824.20641932765,2407.2836542698005]
[32,558824.20641932765,4473.4388130906073,3026.9644514380248,1446.4743616525825,557377.73205767502,2383.227857123145]
[33,557377.73205767502,4473.4388130906073,3019.1293819790731,1454.3094311115342,555923.42262656346,2359.3638226753324]
[34,555923.42262656346,4473.4388130906073,3011.2518725605523,1462.1869405300549,554461.23568603338,2335.6900971773925]
[35,554461.23568603338,4473.4388130906073,3003.3316932993475,1470.1071197912597,552991.12856624217,2312.2052377565587]
[36,552991.12856624217,4473.4388130906073,2995.3686130671454,1478.0702000234619,551513.0583662187,2288.9078123351901]
[37,551513.0583662187,4473.4388130906073,2987.3623994836848,1486.0764136069224,550026.98195261182,2265.7963995502969]
[38,550026.98195261182,4473.4388130906073,2979.3128189099807,1494.1259941806265,548532.85595843114,2242.86958867367]
[39,548532.85595843114,4473.4388130906073,2971.2196364415022,1502.2191766491051,547030.63678178203,2220.1259795326014]
[40,547030.63678178203,4473.4388130906073,2963.0826159013195,1510.3561971892877,545520.28058459272,2197.5641824311974]
[41,545520.28058459272,4473.4388130906073,2954.9015198332108,1518.5372932573964,544001.7432913353,2175.1828180722728]
[42,544001.7432913353,4473.4388130906073,2946.6761094947328,1526.7627035958744,542474.98058773938,2152.9805174798325]
[43,542474.98058773938,4473.4388130906073,2938.4061448502548,1535.0326682403525,540939.94791949901,2130.9559219221301]
[44,540939.94791949901,4473.4388130906073,2930.0913845639529,1543.3474285266543,539396.6004909724,2109.1076828352948]
[45,539396.6004909724,4473.4388130906073,2921.7315859927671,1551.7072270978401,537844.89326387458,2087.4344617475308]
[46,537844.89326387458,4473.4388130906073,2913.3265051793205,1560.1123079112867,536284.7809559633,2065.9349302038804]
[47,536284.7809559633,4473.4388130906073,2904.875896844801,1568.5629162458063,534716.21803971753,2044.6077696915484]
[48,534716.21803971753,4473.4388130906073,2896.3795143818033,1577.0592987088039,533139.15874100872,2023.4516715657796]
[49,533139.15874100872,4473.4388130906073,2887.8371098471307,1585.6017032434765,531553.55703776528,2002.4653369762909]
[50,531553.55703776528,4473.4388130906073,2879.2484339545622,1594.1903791360451,529959.36665862927,1981.6474767942509]
[51,529959.36665862927,4473.4388130906073,2870.6132360675751,1602.8255770230321,528356.54108160618,1960.996811539804]
[52,528356.54108160618,4473.4388130906073,2861.9312641920337,1611.5075488985735,526745.0335327076,1940.5120713101312]
[53,526745.0335327076,4473.4388130906073,2853.2022649688329,1620.2365481217744,525124.79698458582,1920.1919957080511]
[54,525124.79698458582,4473.4388130906073,2844.4259836665065,1629.0128294241008,523495.7841551617,1900.035333771147]
[55,523495.7841551617,4473.4388130906073,2835.6021641737925,1637.8366489168147,521857.94750624488,1880.0408439014293]
[56,521857.94750624488,4473.4388130906073,2826.7305489921596,1646.7082640984477,520211.23924214643,1860.2072937955136]
[57,520211.23924214643,4473.4388130906073,2817.8108792282933,1655.627933862314,518555.6113082841,1840.5334603753247]
[58,518555.6113082841,4473.4388130906073,2808.8428945865389,1664.5959185040683,516891.01538978005,1821.0181297193142]
[59,516891.01538978005,4473.4388130906073,2799.8263333613086,1673.6124797292987,515217.40291005076,1801.660096994191]
[60,515217.40291005076,4473.4388130906073,2790.7609324294417,1682.6778806611655,513534.72502938961,1782.4581663871597]
[61,513534.72502938961,4473.4388130906073,2781.6464272425269,1691.7923858480804,511842.93264354154,1763.4111510386654]
[62,511842.93264354154,4473.4388130906073,2772.4825518191833,1700.956261271424,510141.97638227011,1744.5178729756342]
[63,510141.97638227011,4473.4388130906073,2763.2690387372963,1710.1697743533109,508431.80660791678,1725.7771630452196]
[64,508431.80660791678,4473.4388130906073,2754.0056191262161,1719.4331939643912,506712.37341395236,1707.1878608490347]
[65,506712.37341395236,4473.4388130906073,2744.6920226589086,1728.7467904316986,504983.62662352069,1688.7488146778753]
[66,504983.62662352069,4473.4388130906073,2735.3279775440706,{"$f":"C68-D68","v":1738.1108355465367},{"$f":"B68-E68","v":503245.51578797417},{"$f":"D68/POWER(1+9/1200,A68)","v":1670.4588814469346}]
[{"$f":"A68+1","v":67},{"$f":"IF(F68>0,F68,0)","v":503245.51578797417},{"$f":"IF(B69>0,C68,0)","v":4473.4388130906073},{"$f":"B69*$J$1/1200","v":2725.9132105181934},1747.5256025724138,501497.99018540175,1652.3169266314935]
[68,501497.99018540175,4473.4388130906073,2716.4474468375929,1756.9913662530143,499740.99881914875,1634.3218242030946]
[69,499740.99881914875,4473.4388130906073,2706.9304102703891,1766.5084028202182,497974.49041632854,1616.4724565661884]
[70,497974.49041632854,4473.4388130906073,2697.3618230884463,1776.076990002161,496198.41342632635,1598.7677144952538]
[71,496198.41342632635,4473.4388130906073,2687.7414060592678,1785.6974070313395,494412.71601929504,1581.2064970723857]
[72,494412.71601929504,4473.4388130906073,2678.0688784378481,1795.3699346527592,492617.34608464228,1563.7877116253478]
[73,492617.34608464228,4473.4388130906073,2668.3439579584792,1805.094855132128,490812.25122951018,1546.5102736660851]
[74,490812.25122951018,4473.4388130906073,2658.5663608265131,1814.8724522640941,488997.37877724611,1529.3731068296966]
[75,488997.37877724611,4473.4388130906073,2648.7358017100833,1824.703011380524,487172.6757658656,1512.3751428138644]
[76,487172.6757658656,4473.4388130906073,2638.8519937317719,1834.5868193588353,485338.08894650679,1495.5153213187257]
[77,485338.08894650679,4473.4388130906073,2628.9146484602452,1844.5241646303621,483493.5647818764,1478.7925899872032]
[78,483493.5647818764,4473.4388130906073,2618.9234759018304,1854.5153371887768,481639.04944468761,1462.2059043457712]
[79,481639.04944468761,4473.4388130906073,2608.8781844920582,1864.5606285985491,479774.48881608906,1445.7542277456703]
[80,479774.48881608906,4473.4388130906073,2598.778481087149,1874.6603320034583,477899.82848408562,1429.4365313045516]
[81,477899.82848408562,4473.4388130906073,2588.6240709554636,1884.8147421351437,476015.0137419505,1413.2517938485639]
[82,476015.0137419505,4473.4388130906073,2578.4146577688985,1895.0241553217088,474119.9895866288,1397.1990018548656]
[83,474119.9895866288,4473.4388130906073,2568.1499435942396,1905.2888694963676,472214.70071713242,1381.27714939457]
[84,472214.70071713242,4473.4388130906073,2557.8296288844672,1915.6091842061401,470299.09153292631,1365.4852380761095]
[85,470299.09153292631,4473.4388130906073,2547.4534124700176,1925.9854006205896,468373.10613230569,1349.8222769890306]
[86,468373.10613230569,4473.4388130906073,2537.0209915499895,1936.4178215406178,466436.68831076508,1334.2872826481955]
[87,466436.68831076508,4473.4388130906073,2526.532061683311,1946.9067514072963,464489.78155935777,1318.879278938412]
[88,464489.78155935777,4473.4388130906073,2515.9863167798544,1957.4524963107528,462532.32906304701,1303.5972970594651]
[89,462532.32906304701,4473.4388130906073,2505.3834490915046,1968.0553639991026,460564.27369904792,1288.4403754715654]
[90,460564.27369904792,4473.4388130906073,2494.723149203176,1978.7156638874312,458585.55803516047,1273.4075598411989]
[91,458585.55803516047,4473.4388130906073,2484.0051060237861,1989.4337070668212,456596.12432809366,1258.4979029873844]
[92,456596.12432809366,4473.4388130906073,2473.2290067771742,2000.2098063134331,454595.91452178021,1243.7104648283262]
[93,454595.91452178021,4473.4388130906073,2462.3945369929761,2011.0442760976312,452584.8702456826,1229.0443123284697]
[94,452584.8702456826,4473.4388130906073,2451.5013804974474,2021.9374325931599,450562.93281308946,1214.4985194459462]
[95,450562.93281308946,4473.4388130906073,2440.5492194042349,2032.8895936863723,448530.04321940307,1200.072167080413]
[96,448530.04321940307,4473.4388130906073,2429.5377341050998,2043.9010789855074,446486.14214041759,1185.7643430212797]
[97,446486.14214041759,4473.4388130906073,2418.4666032605951,2054.9722098300122,444431.16993058758,1171.5741418963205]
[98,444431.16993058758,4473.4388130906073,2407.3355037906827,2066.1033092999246,442365.06662128767,1157.5006651206706]
[99,442365.06662128767,4473.4388130906073,2396.144110865308,2077.2947022252993,440287.77191906236,1143.543020846201]
[100,440287.77191906236,4473.4388130906073,2384.8920978949213,2088.5467151956859,438199.22520386666,1129.7003239112707]
[101,438199.22520386666,4473.4388130906073,2373.5791365209443,2099.859676569663,436099.36552729702,1115.9716957908529]
[102,436099.36552729702,4473.4388130906073,2362.2048966061921,2111.2339164844152,433988.13161081262,1102.3562645470342]
[103,433988.13161081262,4473.4388130906073,2350.7690462252349,2122.6697668653724,431865.46184394724,1088.8531647798804]
[104,431865.46184394724,4473.4388130906073,2339.271251654714,2134.1675614358933,429731.29428251134,1075.46153757867]
[105,429731.29428251134,4473.4388130906073,2327.7111773636029,2145.7276357270043,427585.56664678431,1062.1805304734889]
[106,427585.56664678431,4473.4388130906073,2316.0884860034153,2157.350327087192,425428.21631969709,1049.0092973871883]
[107,425428.21631969709,4473.4388130906073,2304.4028383983596,2169.0359746922477,423259.18034500483,1035.9469985876985]
[108,423259.18034500483,4473.4388130906073,2292.6538935354429,2180.7849195551644,421078.39542544965,1022.9928006406979]
[109,421078.39542544965,4473.4388130906073,2280.8413085545189,2192.5975045360883,418885.79792091355,1010.145876362636]
[110,418885.79792091355,4473.4388130906073,2268.964738738282,2204.4740743523253,416681.32384656125,997.40540477410468]
[111,416681.32384656125,4473.4388130906073,2257.0238375022068,2216.4149755884005,414464.90887097287,984.77057105355755]
[112,414464.90887097287,4473.4388130906073,2245.018256384436,2228.4205567061713,412236.48831426672,972.24056649137401]
[113,412236.48831426672,4473.4388130906073,2232.9476450356115,2240.4911680549958,409995.99714621174,959.81458844426595]
[114,409995.99714621174,4473.4388130906073,2220.8116512086467,2252.6271618819605,407743.36998432979,947.49184029002197]
[115,407743.36998432979,4473.4388130906073,2208.6099207484531,2264.8288923421542,405478.54109198763,935.27153138259257]
[116,405478.54109198763,4473.4388130906073,2196.3420975815998,2277.0967155090075,403201.44437647861,923.15287700750434]
[117,403201.44437647861,4473.4388130906073,2184.0078237059261,2289.4309893846812,400912.0133870939,911.1350983376135]
[118,400912.0133870939,4473.4388130906073,2171.6067391800921,2301.8320739105152,398610.18131318339,899.2174223891808]
[119,398610.18131318339,4473.4388130906073,2159.1384821130764,2314.3003309775308,396295.88098220585,887.39908197828083]
[120,396295.88098220585,4473.4388130906073,2146.6026886536151,2326.8361244369921,393969.04485776887,875.67931567753203]
[121,393969.04485776887,4473.4388130906073,2133.9989929795811,2339.4398201110262,391629.60503765784,864.05736777314837]
[122,391629.60503765784,4473.4388130906073,2121.3270272873133,2352.111785803294,389277.49325185455,852.53248822231535]
[123,389277.49325185455,4473.4388130906073,2108.5864217808789,2364.8523913097283,386912.64086054481,841.10393261087813]
[124,386912.64086054481,4473.4388130906073,2095.7768046612841,2377.6620084293231,384534.97885211551,829.77096211134847]
[125,384534.97885211551,4473.4388130906073,2082.8978021156258,2390.5410109749814,382144.43784114055,818.53284344122449]
[126,382144.43784114055,4473.4388130906073,2069.949038306178,2403.4897747844293,379740.94806635613,807.38884882161608]
[127,379740.94806635613,4473.4388130906073,2056.9301353594287,2416.5086777311785,377324.43938862497,796.33825593618644]
[128,377324.43938862497,4473.4388130906073,2043.840713355052,2429.5980997355555,374894.84128888941,785.38034789039364]
[129,374894.84128888941,4473.4388130906073,2030.6803903148175,2442.7584227757898,372452.08286611363,774.51441317103479]
[130,372452.08286611363,4473.4388130906073,2017.4487821914488,{"$f":"C132-D132","v":2455.9900308991582},{"$f":"B132-E132","v":369996.09283521445},{"$f":"D132/POWER(1+9/1200,A132)","v":763.73974560609815}]
[{"$f":"A132+1","v":131},{"$f":"IF(F132>0,F132,0)","v":369996.09283521445},{"$f":"IF(B133>0,C132,0)","v":4473.4388130906073},{"$f":"B133*$J$1/1200","v":2004.1455028574114},2469.2933102331958,367526.79952498124,753.05564432490792]
[132,367526.79952498124,4473.4388130906073,1990.7701640936484,2482.6686489969588,365044.13087598427,742.46141371856891]
[133,365044.13087598427,4473.4388130906073,1977.3223755782483,2496.116437512359,362548.01443847193,731.9563634007045]
[134,362548.01443847193,4473.4388130906073,1963.8017448750561,2509.6370682155512,360038.37737025641,721.53980816848843]
[135,360038.37737025641,4473.4388130906073,1950.2078774222223,2523.230935668385,357515.14643458801,711.21106796396646]
[136,357515.14643458801,4473.4388130906073,1936.540376520685,2536.8984365699225,354978.24799801811,700.96946783566466]
[137,354978.24799801811,4473.4388130906073,1922.798843322598,2550.639969768009,352427.60802825011,690.81433790048618]
[138,352427.60802825011,4473.4388130906073,1908.982876819688,2564.4559362709192,349863.15209197917,680.74501330588987]
[139,349863.15209197917,4473.4388130906073,1895.092073831554,2578.3467392590533,347284.80535272014,670.76083419235135]
[140,347284.80535272014,4473.4388130906073,1881.1260289939007,2592.3127840967063,344692.49256862345,660.8611456561041]
[141,344692.49256862345,4473.4388130906073,1867.0843347467103,2606.354478343897,342086.13809027954,651.04529771215766]
[142,342086.13809027954,4473.4388130906073,1852.9665813223473,2620.4722317682599,339465.66585851129,641.31264525759013]
[143,339465.66585851129,4473.4388130906073,1838.7723567336029,2634.6664563570043,336830.9994021543,631.66254803511754]
[144,336830.9994021543,4473.4388130906073,1824.5012467616691,2648.9375663289384,334182.06183582539,622.09437059693073]
[145,334182.06183582539,4473.4388130906073,1810.1528349440541,2663.2859781465531,331518.77585767885,612.60748226880344]
[146,331518.77585767885,4473.4388130906073,1795.7267025624269,2677.7121105281803,328841.06374715065,603.20125711446804]
[147,328841.06374715065,4473.4388130906073,1781.2224286303995,2692.2163844602078,326148.84736269043,593.87507390025689]
[148,326148.84736269043,4473.4388130906073,1766.63958988124,2706.7992232093675,323442.04813948105,584.62831606000452]
[149,323442.04813948105,4473.4388130906073,1751.9777607555222,2721.4610523350848,320720.58708714595,575.46037166021506]
[150,320720.58708714595,4473.4388130906073,1737.2365133887072,2736.2022997019003,317984.38478744403,566.37063336548601]
[151,317984.38478744403,4473.4388130906073,1722.415417598655,2751.0233954919522,315233.36139195209,557.35849840419201]
[152,315233.36139195209,4473.4388130906073,1707.5140408730738,2765.9247722175332,312467.43661973457,548.42336853442202]
[153,312467.43661973457,4473.4388130906073,1692.5319483568956,2780.9068647337117,309686.52975500084,539.56465001017125]
[154,309686.52975500084,4473.4388130906073,1677.4687028395879,2795.9701102510194,306890.5596447498,530.78175354778625]
[155,306890.5596447498,4473.4388130906073,1662.3238647423946,2811.1149483482127,304079.4446964016,522.07409429265749]
[156,304079.4446964016,4473.4388130906073,1647.0969921055087,2826.3418209850988,301253.10287541652,513.44109178616191]
[157,301253.10287541652,4473.4388130906073,1631.7876405751729,2841.6511725154342,298411.4517029011,504.88216993285107]
[158,298411.4517029011,4473.4388130906073,1616.3953633907142,2857.0434496998932,295554.40825320123,496.39675696788305]
[159,295554.40825320123,4473.4388130906073,1600.9197113715065,2872.5191017191009,292681.88915148214,487.98428542469941]
[160,292681.88915148214,4473.4388130906073,1585.3602329038615,2888.078580186746,289793.81057129538,479.6441921029396]
[161,289793.81057129538,4473.4388130906073,1569.7164739278501,2903.7223391627572,286890.08823213261,471.37591803659672]
[162,286890.08823213261,4473.4388130906073,1553.9879779240516,2919.4508351665554,283970.63739696605,463.17890846240954]
[163,283970.63739696605,4473.4388130906073,1538.1742859002327,2935.2645271903748,281035.37286977569,455.05261278849139]
[164,281035.37286977569,4473.4388130906073,1522.2749363779517,2951.1638767126556,278084.20899306302,446.99648456319034]
[165,278084.20899306302,4473.4388130906073,1506.2894653790913,2967.1493477115159,275117.05964535149,439.00998144418304]
[166,275117.05964535149,4473.4388130906073,1490.2174064123205,2983.2214066782867,272133.83823867323,431.09256516779897]
[167,272133.83823867323,4473.4388130906073,1474.0582904594798,2999.3805226311274,269134.45771604212,423.24370151857249]
[168,269134.45771604212,4473.4388130906073,1457.8116459618948,3015.6271671287122,266118.83054891339,415.46286029902177]
[169,266118.83054891339,4473.4388130906073,1441.4769988066143,3031.9618142839927,263086.86873462942,407.74951529965296]
[170,263086.86873462942,4473.4388130906073,1425.053872312576,3048.3849407780313,260038.4837938514,400.10314426918842]
[171,260038.4837938514,4473.4388130906073,1408.541787216695,3064.8970258739123,256973.58676797748,392.5232288850159]
[172,256973.58676797748,4473.4388130906073,1391.9402616598782,3081.4985514307291,253892.08821654675,385.00925472385848]
[173,253892.08821654675,4473.4388130906073,1375.2488111729615,3098.1900019176455,250793.89821462909,377.5607112326623]
[174,250793.89821462909,4473.4388130906073,1358.4669486625744,3114.9718644280329,247678.92635020107,370.17709169970226]
[175,247678.92635020107,4473.4388130906073,1341.5941843969226,3131.8446286936846,244547.08172150739,362.85789322590216]
[176,244547.08172150739,4473.4388130906073,1324.6300259914985,3148.8087870991085,241398.27293440828,355.60261669636839]
[177,241398.27293440828,4473.4388130906073,1307.5739783947115,3165.8648346958958,238232.40809971237,348.41076675213657]
[178,238232.40809971237,4473.4388130906073,1290.4255438734419,3183.0132692171655,235049.39483049521,341.28185176212787]
[179,235049.39483049521,4473.4388130906073,1273.1842219985156,3200.2545910920917,231849.14023940312,334.21538379531495]
[180,231849.14023940312,4473.4388130906073,1255.8495096301003,3217.5893034605069,228631.55093594262,327.21087859309426]
[181,{"$f":"IF(F182>0,F182,0)","v":228631.55093594262},{"$f":"IF(B183>0,C182,0)","v":4473.4388130906073},{"$f":"B183*$J$1/1200","v":1238.4209009030224},{"$f":"C183-D183","v":3235.0179121875849},{"$f":"B183-E183","v":225396.53302375504},{"$f":"D183/POWER(1+9/1200,A183)","v":320.26785554186523}]
[182,225396.53302375504,4473.4388130906073,1220.8978872120065,3252.5409258786008,222143.99209787644,313.38583764581335]
[183,222143.99209787644,4473.4388130906073,1203.2799571968308,3270.1588558937765,218873.83324198268,306.56435149989579]
[184,218873.83324198268,4473.4388130906073,1185.5665967274062,3287.872216363201,215585.96102561947,299.80292726302866]
[185,215585.96102561947,4473.4388130906073,1167.7572888887721,3305.6815242018351,212280.27950141762,293.1010986314738]
[186,212280.27950141762,4473.4388130906073,1149.8515139660121,3323.5872991245951,208956.69220229302,286.45840281242414]
[187,208956.69220229302,4473.4388130906073,1131.8487494290873,3341.5900636615197,205615.10213863151,279.87438049778547]
[188,205615.10213863151,4473.4388130906073,1113.7484699175873,3359.6903431730198,202255.41179545849,273.34857583815375]
[189,202255.41179545849,4473.4388130906073,1095.5501472254002,3377.8886658652073,198877.52312959329,266.88053641698667]
[190,198877.52312959329,4473.4388130906073,1077.2532502852971,3396.1855628053099,195481.33756678799,260.46981322496652]
[191,195481.33756678799,4473.4388130906073,1058.8572451534349,3414.5815679371726,192066.75599885083,254.11596063455556]
[192,192066.75599885083,4473.4388130906073,1040.3615949937753,3433.077218096832,188633.67878075401,247.81853637474035]
[193,188633.67878075401,4473.4388130906073,1021.7657600624176,3451.6730530281898,185182.00572772583,241.57710150596324]
[194,185182.00572772583,4473.4388130906073,1003.0691976918482,3470.3696153987589,181711.63611232708,235.39122039524247]
[{"$f":"A196+1","v":195},181711.63611232708,4473.4388130906073,984.27136227510505,3489.167450815502,178222.46866151158,229.26046069147642]
[196,178222.46866151158,4473.4388130906073,965.37170524985436,3508.0671078407531,174714.40155367082,223.18439330093227]
[197,174714.40155367082,4473.4388130906073,946.36967508238354,3527.0691380082235,171187.33241566259,217.16259236291694]
[198,171187.33241566259,4473.4388130906073,927.26471725150577,3546.1740958391015,167641.1583198235,211.19463522563001]
[199,167641.1583198235,4473.4388130906073,908.0562742323774,3565.38253885823,164075.77578096528,205.28010242219574]
[200,164075.77578096528,4473.4388130906073,888.74378548022867,3584.6950276103785,160491.08075335491,199.41857764687433]
[201,160491.08075335491,4473.4388130906073,869.32668741400573,3604.1121256766014,156886.96862767832,193.60964773144994]
[202,156886.96862767832,4473.4388130906073,849.80441339992421,3623.634399690683,153263.33422798762,187.8529026217951]
[203,153263.33422798762,4473.4388130906073,830.17639373493296,3643.2624193556744,149620.07180863194,182.14793535460936]
[204,149620.07180863194,4473.4388130906073,810.44205563008973,3662.9967574605175,145957.07505117141,176.49434203433159]
[205,145957.07505117141,4473.4388130906073,790.60082319384514,3682.8379898967623,142274.23706127465,170.89172181022391]
[206,142274.23706127465,4473.4388130906073,770.65211741523774,3702.7866956753696,138571.45036559927,165.33967685362674]
[207,138571.45036559927,4473.4388130906073,750.5953561469961,3722.8434569436113,134848.60690865567,159.83781233538335]
[208,134848.60690865567,4473.4388130906073,730.42995408855154,3743.0088590020559,131105.59804965361,154.38573640343222]
[209,131105.59804965361,4473.4388130906073,710.15532276895703,3763.2834903216503,127342.31455933195,148.98306016056665]
[210,127342.31455933195,4473.4388130906073,689.77087052971478,3783.6679425608927,123558.64661677106,143.62939764236029]
[211,123558.64661677106,4473.4388130906073,669.27600250750993,3804.1628105830973,119754.48380618796,138.3243657952568]
[212,119754.48380618796,4473.4388130906073,648.67012061685136,3824.7686924737559,115929.71511371421,133.06758445482279]
[213,115929.71511371421,4473.4388130906073,627.95262353261865,3845.4861895579888,112084.22892415622,127.85867632416333]
[214,112084.22892415622,4473.4388130906073,607.12290667251284,3866.3159064180945,108217.91301773813,122.69726695249729]
[215,108217.91301773813,4473.4388130906073,586.18036217941483,3887.2584509111925,104330.65456682694,117.58298471389364]
[216,104330.65456682694,4473.4388130906073,565.12437890364595,3908.3144341869611,100422.34013263998,112.51546078616492]
[217,100422.34013263998,4473.4388130906073,543.95434238513326,3929.484470705474,96492.855661934504,107.49432912991888]
[218,96492.855661934504,4473.4388130906073,522.66963483547863,3950.7691782551287,92542.086483679377,102.51922646776592]
[219,92542.086483679377,4473.4388130906073,501.26963511992994,3972.1691779706771,88569.917305708703,97.589792263681289]
[220,88569.917305708703,4473.4388130906073,479.75371873925548,3993.6850943513518,84576.232211357346,92.705668702521479]
[221,84576.232211357346,4473.4388130906073,458.12125781151894,4015.3175552790881,80560.914656078254,87.866500669692854]
[222,80560.914656078254,4473.4388130906073,436.37162105375722,4037.06719203685,76523.847464041406,83.071935730972044]
[223,76523.847464041406,4473.4388130906073,414.50417376355762,4058.9346393270498,72464.912824714353,78.321624112476684]
[224,72464.912824714353,4473.4388130906073,392.51827780053605,4080.9205352900713,68383.992289424277,73.615218680785304]
[225,68383.992289424277,4473.4388130906073,370.41329156771479,4103.0255215228926,64280.966767901387,68.952374923205412]
[226,64280.966767901387,4473.4388130906073,348.18856999279916,4125.2502430978084,60155.716524803582,64.332750928188759]
[227,60155.716524803582,4473.4388130906073,325.84346450935271,4147.5953485812543,56008.121176222325,59.756007365892351]
[228,56008.121176222325,4473.4388130906073,303.37732303787089,4170.0614900527362,51838.059686169589,55.2218074688844]
[229,51838.059686169589,4473.4388130906073,280.78948996675194,4192.6493231238555,47645.410363045732,50.729817012994133]
[230,47645.410363045732,4473.4388130906073,258.07930613316438,4215.359506957443,43430.050856088288,46.279704298304168]
[231,43430.050856088288,4473.4388130906073,235.24610880381155,4238.1927042867956,39191.858151801491,41.871140130284722]
[232,39191.858151801491,4473.4388130906073,212.28923165559141,4261.1495814350155,34930.708570366478,37.503797801068231]
[233,34930.708570366478,4473.4388130906073,189.20800475615175,4284.2308083344551,30646.477762032024,33.177353070863653]
[234,30646.477762032024,4473.4388130906073,166.00175454434012,4307.4370585462675,26339.040703485756,28.891484149509207]
[235,26339.040703485756,4473.4388130906073,142.66980381054785,4330.7690092800594,22008.271694205698,24.645871678162646]
[236,22008.271694205698,4473.4388130906073,119.21147167694753,4354.2273414136598,17654.044352792036,20.440198711127895]
[237,17654.044352792036,4473.4388130906073,95.626073577623529,4377.8127395129841,13276.231613279051,16.274150697817255]
[238,13276.231613279051,4473.4388130906073,71.912921238594862,4401.5258918520121,8874.705721427039,12.147415464847921]
[239,{"$f":"IF(F240>0,F240,0)","v":8874.705721427039},{"$f":"IF(B241>0,C240,0)","v":4473.4388130906073},{"$f":"B241*$J$1/1200","v":48.071322657729795},{"$f":"C241-D241","v":4425.3674904328773},{"$f":"B241-E241","v":4449.3382309941617},{"$f":"D241/POWER(1+9/1200,A241)","v":8.059683198272003}]
[240,4449.3382309941617,4473.4388130906073,24.100582084551711,4449.3382310060551,-1.1893462215084583E-8,4.0106464259389343]
[null,null,{"$f":"SUM(C3:C242)","v":1073625.3151417403},{"$f":"SUM(D3:D242)","v":473625.31514173379},600000.00000001176]

{"sheet":"Sheet1","index":2,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Please enable macros"]